﻿CREATE TABLE [trUser].[tblDriverPassengerLogs] (
    [IDDriverPassengerLog] BIGINT        IDENTITY (1, 1) NOT NULL,
    [IDDriverPassenger]    BIGINT        NOT NULL,
    [DateOfRide]           DATETIME      NOT NULL,
    [Cost]                 MONEY         NULL,
    [CostCurrency]         NVARCHAR (10) NULL,
    [Distance]             FLOAT (53)    NULL,
    [DistanceUnit]         NVARCHAR (10) NULL,
    [DateCreated]          DATETIME      CONSTRAINT [DF_tblDriverPassengerLogs_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]          DATETIME      NULL,
    [DateInactive]         DATETIME      NULL,
    CONSTRAINT [PK_tblDriverPassengerLogs] PRIMARY KEY CLUSTERED ([IDDriverPassengerLog] ASC)
);

